

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.io.*;
import java.sql.*;
import java.util.Iterator;
import java.util.Vector;
import oracle.jdbc.driver.OracleDriver;



public class ComboBox {

    ResultSet RS_ProvID;
    Statement STMT_comando;
    Connection OJDBC_con;

void ccProv () {
        ConexionBD BD_con = new ConexionBD();
        try{
        OJDBC_con= BD_con.DBConect();
        System.out.println("CONNECTED TO   ---> ");
        STMT_comando = OJDBC_con.createStatement ();
        String STR_query ="SELECT prov_id, prov_nombre FROM tbm_proveedores ORDER BY prov_id";
        RS_ProvID = STMT_comando.executeQuery(STR_query);
        System.out.println("EXECUTED QUERY ---> " + STR_query);
        System.out.println("\nPROCESSING RESULTS:\n");
       
      }catch (SQLException e) {
        e.printStackTrace();
      }
}

public boolean SigReg_RS (ResultSet RS) {
    boolean b_next = false;
    try{
      System.out.println("Siguiente REsultado");
      b_next = RS.next();
      }catch (SQLException e) {
        e.printStackTrace();
            }
return b_next;
}
public String AddSigReg(ResultSet RS, int int_posicion){
    String str_registro;
    str_registro = new String();
    try{
    str_registro = RS.getString(int_posicion);
    }catch (SQLException e) {
        e.printStackTrace();
      }
 return str_registro;
}

void cleanProv(){
    try{
    RS_ProvID.close();
    STMT_comando.close();
    OJDBC_con.close();

    }catch (SQLException e) {
        e.printStackTrace();
      }

}



     public static void main(String[] args) {




      }

}

